package com.deyuanyun.pic.ctrl.excelImport;

import com.deyuanyun.pic.common.validator.annotations.DataValidate;
import com.deyuanyun.pic.ctrl.annotation.*;
import com.deyuanyun.pic.ctrl.util.AutoImportInterface;
import com.deyuanyun.pic.ctrl.validatefun.EnumValidata;
import com.deyuanyun.pic.ctrl.validatefun.OclpointValidata;
import com.deyuanyun.pic.pipe.validatefun.PipeLineValidata;

import java.util.Date;

/**

说明:Z:\7外涂层漏损点开挖检测记录表（导入、导出）.xls

**/
@DbTable(name="PIC_CTRL_EXINSP_OCLPOINT_DIG",startRow=6,sumCell=45,excelName="7外涂层漏损点开挖检测记录表（导入、导出）.xls")
public class PicCtrlExinspOclpointDigExcel implements AutoImportInterface
{

      /**
      * 管道名称
      */
      @Head( name="管道名称",row=2,cell=0)
      @DbFiled( name="PIPE_LINE_ID" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = PipeLineValidata.class,myFunctionMessage="管道信息与项目要求管道不一致")
      private String pipeLineId;

      /**
      * 防腐层漏损点编号
      */
      @Head( name="防腐层漏损点编号",row=2,cell=1)
      @DbFiled( name="OCLPOINT_ID" ,type="CHAR")
      @DataValidate(notNull = true,myFunction = OclpointValidata.class,myFunctionMessage = "防腐层漏损点数据库无对应数据")
      private String oclpointId;

      /**
      * X
      */
      @Head( name="X",row=5,cell=2)
      @DbFiled( name="POSITION_X" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String positionX;

      /**
      * Y
      */
      @Head( name="Y",row=5,cell=3)
      @DbFiled( name="POSITION_Y" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String positionY;

      /**
      * Z
      */
      @Head( name="Z",row=5,cell=4)
      @DbFiled( name="POSITION_Z" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String positionZ;

      /**
      * 位置描述
      */
      @Head( name="位置描述",row=2,cell=5)
      @DbFiled( name="LOCATION_DESC" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String locationDesc;

      /**
      * 地形地貌描述
      */
      @Head( name="地形地貌描述",row=2,cell=6)
      @DbFiled( name="TERRAIN_GEOMORPHO_DESC" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String terrainGeomorphoDesc;

      /**
      * 地下水
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.GroundWaterEnum.class,valMethod="getVal")
      @Head( name="地下水",row=2,cell=7)
      @DbFiled( name="GROUND_WATER" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String groundWater;

      /**
      * 土壤电阻率（Ω·m）
      */
      @Head( name="土壤电阻率（Ω·m）",row=2,cell=8)
      @DbFiled( name="SOIL_RESISTIVITY" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String soilResistivity;

      /**
      * 管/地电位（mV）
      */
      @Head( name="管/地电位（mV）",row=2,cell=9)
      @DbFiled( name="PIPE_TO_SOIL_POTENTIAL" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String tubeGroundPotential;

      /**
      * 自然电位（mV）
      */
      @Head( name="自然电位（mV）",row=2,cell=10)
      @DbFiled( name="FREE_CORR_POTENTIAL" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String freecorrosionpotential;

      /**
      * 交流电压（V）
      */
      @Head( name="交流电压（V）",row=2,cell=11)
      @DbFiled( name="AC_POTENTIAL" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String acPotential;

      /**
      * 土壤颜色
      */
      @Head( name="土壤颜色",row=4,cell=12)
      @DbFiled( name="SOIL_COLOR" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String soilColor;

      /**
      * 土壤干湿度
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.SoilHumidityEnum.class,valMethod="getVal")
      @Head( name="土壤干湿度",row=4,cell=13)
      @DbFiled( name="SOIL_HUMIDITY" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String soilHumidity;

      /**
      * 土壤松紧度
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.SoilCompactnessEnum.class,valMethod="getVal")
      @Head( name="土壤松紧度",row=4,cell=14)
      @DbFiled( name="SOIL_COMPACTNESS" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String soilCompactness;

      /**
      * 根系植物
      */
      @EnumVail(enumClass=com.deyuanyun.pic.ctrl.enumeration.DeeprootedPlantsEnum.class,valMethod="getVal")
      @Head( name="根系植物",row=4,cell=15)
      @DbFiled( name="DEEPROOTED_PLANTS" ,type="VARCHAR2")
      @DataValidate(notNull = true,myFunctionMessage="可选值无对应值",myFunction = EnumValidata.class)
      private String deeprootedPlants;

      /**
      * pH值
      */
      @Head( name="pH值",row=4,cell=16)
      @DbFiled( name="SOIL_PH" ,type="NUMBER")
      @DataValidate(notNull = true,type = Integer.class,numberRang="{0,14}",numberRangMessage = "数字范围不符合规范0~14")
      private String soilPh;

      /**
      * 氧化还原电位（mV）
      */
      @Head( name="氧化还原电位（mV）",row=4,cell=17)
      @DbFiled( name="REDOX_POTENTIAL" ,type="NUMBER")
      @DataValidate(type = Number.class,notNull = true)
      private String redoxPotential;

      /**
      * 含水率（%）
      */
      @Head( name="含水率（%）",row=4,cell=18)
      @DbFiled( name="MOISTURE_CONTENT" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String moistureContent;

      /**
      * 含盐量（%）
      */
      @Head( name="含盐量（%）",row=4,cell=19)
      @DbFiled( name="SALT_CONTENT" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String saltContent;

      /**
      * 氯离子（%）
      */
      @Head( name="氯离子（%）",row=4,cell=20)
      @DbFiled( name="CHLORIDEION" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String chlorideion;

      /**
      * 硫酸根离子（%）
      */
      @Head( name="硫酸根离子（%）",row=4,cell=21)
      @DbFiled( name="SULFATEION" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String sulfateion;

      /**
      * 外观描述
      */
      @Head( name="外观描述",row=3,cell=22)
      @DbFiled( name="APPEARANCE" ,type="VARCHAR2")
      @DataValidate(notNull = true,lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String appearance;

      /**
      * 0.0
      */
      @Head( name="0:00",row=4,cell=23)
      @DbFiled( name="TEST1" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String test1;

      /**
      * 0.125
      */
      @Head( name="3:00",row=4,cell=24)
      @DbFiled( name="TEST2" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String test2;

      /**
      * 0.25
      */
      @Head( name="6:00",row=4,cell=25)
      @DbFiled( name="TEST3" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String test3;

      /**
      * 0.375
      */
      @Head( name="9:00",row=4,cell=26)
      @DbFiled( name="TEST4" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String test4;

      /**
      * 检漏电压（KV）
      */
      @Head( name="检漏电压（KV）",row=4,cell=27)
      @DbFiled( name="TEST_VOLTAGE" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String testVoltage;

      /**
      * 漏点数
      */
      @Head( name="漏点数",row=4,cell=28)
      @DbFiled( name="AMOUNT" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String amount;

      /**
      * 附着力/撬剥法（级）
      */
      @Head( name="附着力/撬剥法（级）",row=4,cell=29)
      @DbFiled( name="ADHESION" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String adhesion;

      /**
      * 粘结强度/拉开法（MPa）
      */
      @Head( name="粘结强度/拉开法（MPa）",row=4,cell=30)
      @DbFiled( name="BONDSTRENGTH" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String bondstrength;

      /**
      * 对钢
      */
      @Head( name="对钢",row=5,cell=31)
      @DbFiled( name="FORSTEEL" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String forsteel;

      /**
      * 对管体防腐层
      */
      @Head( name="对管体防腐层",row=5,cell=32)
      @DbFiled( name="PIPE_ANTICORR_LAYER" ,type="NUMBER")
      @DataValidate(notNull = true,type = Number.class)
      private String pipeAnticorrLayer;

      /**
      * 管体壁厚（mm）
      */
      @Head( name="管体壁厚（mm）",row=5,cell=33)
      @DbFiled( name="WALL_THICKNESS" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String wallThickness;

      /**
      * 最大腐蚀坑深度（mm）
      */
      @Head( name="最大腐蚀坑深度（mm）",row=5,cell=34)
      @DbFiled( name="MAX_CORR_DEPTH" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String maxCorrDepth;

      /**
      * 最小剩余壁厚（mm）
      */
      @Head( name="最小剩余壁厚（mm）",row=5,cell=35)
      @DbFiled( name="MIN_RESIDUAL_WALL_THICK" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String minResidualWallThick;

      /**
      * 腐蚀缺陷最大轴向长度（mm）
      */
      @Head( name="腐蚀缺陷最大轴向长度（mm）",row=5,cell=36)
      @DbFiled( name="MAX_AXIAL_CORR_DEFECTS" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String maxAxialCorrDefects;

      /**
      * 腐蚀缺陷最大周向长度（mm）
      */
      @Head( name="腐蚀缺陷最大周向长度（mm）",row=5,cell=37)
      @DbFiled( name="MAX_CIRC_CORR_DEFECTS" ,type="NUMBER")
      @DataValidate(type = Number.class)
      private String maxCircCorrDefects;

      /**
      * 管体修复建议
      */
      @Head( name="管体修复建议",row=5,cell=38)
      @DbFiled( name="PIPE_BODY_REPAIR" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String pipeBodyRepair;

      /**
      * 检测日期
      */
      @Head( name="检测日期",row=2,cell=39)
      @DbFiled( name="TESTING_DATE" ,type="DATE")
      @DataValidate(type = Date.class,notNull = true,datePattern = "yyyyMMdd")
      private String testingDate;

      /**
      * 检测单位
      */
      @Head( name="检测单位",row=2,cell=40)
      @DbFiled( name="TESTING_COMPANY" ,type="VARCHAR2")
      @DataValidate(notNull = true,lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String testingCompany;

      /**
      * 记录人
      */
      @Head( name="记录人",row=2,cell=41)
      @DbFiled( name="RECORDER" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String recorder;

      /**
      * 记录时间
      */
      @Head( name="记录时间",row=2,cell=42)
      @DbFiled( name="RECORD_TIME" ,type="DATE")
      @DataValidate(type = Date.class)
      private String recordTime;

      /**
      * 备注
      */
      @Head( name="备注",row=2,cell=43)
      @DbFiled( name="REMARKS" ,type="VARCHAR2")
      @DataValidate(lengthLimit="50",lengthLimitMessage = "长度不符合规范，最多50个字")
      private String remarks;

      /**
      * id
      */
      @DbFiled( name="ID_")
      @AutoId
      private String id;

    @DbFiled( name="MILEAGE" ,type="NUMBER")
    private String mileage;


    @DbFiled( name="NAGM")
    private String nagm;

    @DbFiled( name="NAGM_MILEAGE",type = "NUMBER")
    private String nagmMileage;

    public String getNagm() {
        return nagm;
    }

    public void setNagm(String nagm) {
        this.nagm = nagm;
    }

    public String getNagmMileage() {
        return nagmMileage;
    }

    public void setNagmMileage(String nagmMileage) {
        this.nagmMileage = nagmMileage;
    }

    @AutoExinspTask
    @DbFiled( name="EXINSP_TASK_ID",type="VARCHAR2")
    private String exinspTaskId;

    @DbFiled( name="DATA_STATED",type="VARCHAR2")
    private String dataStated;

    @DbFiled( name="IS_NEWEST",type="NUMBER")
    private String isNewset;

    public String getExinspTaskId() {
        return exinspTaskId;
    }

    public void setExinspTaskId(String exinspTaskId) {
        this.exinspTaskId = exinspTaskId;
    }

    public String getDataStated() {
        return dataStated;
    }

    public void setDataStated(String dataStated) {
        this.dataStated = dataStated;
    }

    public String getIsNewset() {
        return isNewset;
    }

    public void setIsNewset(String isNewset) {
        this.isNewset = isNewset;
    }

    public String getMileage() {
        return mileage;
    }

    public void setMileage(String mileage) {
        this.mileage = mileage;
    }

    public String getPipeLineId()
    {

        return  this.pipeLineId;
    }
    public void setPipeLineId(String pipeLineId)
    {

      this.pipeLineId=pipeLineId;
    }


    public String getOclpointId()
    {

        return  this.oclpointId;
    }
    public void setOclpointId(String oclpointId)
    {

      this.oclpointId=oclpointId;
    }


    public String getPositionX()
    {

        return  this.positionX;
    }
    public void setPositionX(String positionX)
    {

      this.positionX=positionX;
    }


    public String getPositionY()
    {

        return  this.positionY;
    }
    public void setPositionY(String positionY)
    {

      this.positionY=positionY;
    }


    public String getPositionZ()
    {

        return  this.positionZ;
    }
    public void setPositionZ(String positionZ)
    {

      this.positionZ=positionZ;
    }


    public String getLocationDesc()
    {

        return  this.locationDesc;
    }
    public void setLocationDesc(String locationDesc)
    {

      this.locationDesc=locationDesc;
    }


    public String getTerrainGeomorphoDesc()
    {

        return  this.terrainGeomorphoDesc;
    }
    public void setTerrainGeomorphoDesc(String terrainGeomorphoDesc)
    {

      this.terrainGeomorphoDesc=terrainGeomorphoDesc;
    }


    public String getGroundWater()
    {

        return  this.groundWater;
    }
    public void setGroundWater(String groundWater)
    {

      this.groundWater=groundWater;
    }


    public String getSoilResistivity()
    {

        return  this.soilResistivity;
    }
    public void setSoilResistivity(String soilResistivity)
    {

      this.soilResistivity=soilResistivity;
    }


    public String getTubeGroundPotential()
    {

        return  this.tubeGroundPotential;
    }
    public void setTubeGroundPotential(String tubeGroundPotential)
    {

      this.tubeGroundPotential=tubeGroundPotential;
    }


    public String getFreecorrosionpotential()
    {

        return  this.freecorrosionpotential;
    }
    public void setFreecorrosionpotential(String freecorrosionpotential)
    {

      this.freecorrosionpotential=freecorrosionpotential;
    }


    public String getAcPotential()
    {

        return  this.acPotential;
    }
    public void setAcPotential(String acPotential)
    {

      this.acPotential=acPotential;
    }


    public String getSoilColor()
    {

        return  this.soilColor;
    }
    public void setSoilColor(String soilColor)
    {

      this.soilColor=soilColor;
    }


    public String getSoilHumidity()
    {

        return  this.soilHumidity;
    }
    public void setSoilHumidity(String soilHumidity)
    {

      this.soilHumidity=soilHumidity;
    }


    public String getSoilCompactness()
    {

        return  this.soilCompactness;
    }
    public void setSoilCompactness(String soilCompactness)
    {

      this.soilCompactness=soilCompactness;
    }


    public String getDeeprootedPlants()
    {

        return  this.deeprootedPlants;
    }
    public void setDeeprootedPlants(String deeprootedPlants)
    {

      this.deeprootedPlants=deeprootedPlants;
    }


    public String getSoilPh()
    {

        return  this.soilPh;
    }
    public void setSoilPh(String soilPh)
    {

      this.soilPh=soilPh;
    }


    public String getRedoxPotential()
    {

        return  this.redoxPotential;
    }
    public void setRedoxPotential(String redoxPotential)
    {

      this.redoxPotential=redoxPotential;
    }


    public String getMoistureContent()
    {

        return  this.moistureContent;
    }
    public void setMoistureContent(String moistureContent)
    {

      this.moistureContent=moistureContent;
    }


    public String getSaltContent()
    {

        return  this.saltContent;
    }
    public void setSaltContent(String saltContent)
    {

      this.saltContent=saltContent;
    }


    public String getChlorideion()
    {

        return  this.chlorideion;
    }
    public void setChlorideion(String chlorideion)
    {

      this.chlorideion=chlorideion;
    }


    public String getSulfateion()
    {

        return  this.sulfateion;
    }
    public void setSulfateion(String sulfateion)
    {

      this.sulfateion=sulfateion;
    }


    public String getAppearance()
    {

        return  this.appearance;
    }
    public void setAppearance(String appearance)
    {

      this.appearance=appearance;
    }


    public String getTest1()
    {

        return  this.test1;
    }
    public void setTest1(String test1)
    {

      this.test1=test1;
    }


    public String getTest2()
    {

        return  this.test2;
    }
    public void setTest2(String test2)
    {

      this.test2=test2;
    }


    public String getTest3()
    {

        return  this.test3;
    }
    public void setTest3(String test3)
    {

      this.test3=test3;
    }


    public String getTest4()
    {

        return  this.test4;
    }
    public void setTest4(String test4)
    {

      this.test4=test4;
    }


    public String getTestVoltage()
    {

        return  this.testVoltage;
    }
    public void setTestVoltage(String testVoltage)
    {

      this.testVoltage=testVoltage;
    }


    public String getAmount()
    {

        return  this.amount;
    }
    public void setAmount(String amount)
    {

      this.amount=amount;
    }


    public String getAdhesion()
    {

        return  this.adhesion;
    }
    public void setAdhesion(String adhesion)
    {

      this.adhesion=adhesion;
    }


    public String getBondstrength()
    {

        return  this.bondstrength;
    }
    public void setBondstrength(String bondstrength)
    {

      this.bondstrength=bondstrength;
    }


    public String getForsteel()
    {

        return  this.forsteel;
    }
    public void setForsteel(String forsteel)
    {

      this.forsteel=forsteel;
    }


    public String getPipeAnticorrLayer()
    {

        return  this.pipeAnticorrLayer;
    }
    public void setPipeAnticorrLayer(String pipeAnticorrLayer)
    {

      this.pipeAnticorrLayer=pipeAnticorrLayer;
    }


    public String getWallThickness()
    {

        return  this.wallThickness;
    }
    public void setWallThickness(String wallThickness)
    {

      this.wallThickness=wallThickness;
    }


    public String getMaxCorrDepth()
    {

        return  this.maxCorrDepth;
    }
    public void setMaxCorrDepth(String maxCorrDepth)
    {

      this.maxCorrDepth=maxCorrDepth;
    }


    public String getMinResidualWallThick()
    {

        return  this.minResidualWallThick;
    }
    public void setMinResidualWallThick(String minResidualWallThick)
    {

      this.minResidualWallThick=minResidualWallThick;
    }


    public String getMaxAxialCorrDefects()
    {

        return  this.maxAxialCorrDefects;
    }
    public void setMaxAxialCorrDefects(String maxAxialCorrDefects)
    {

      this.maxAxialCorrDefects=maxAxialCorrDefects;
    }


    public String getMaxCircCorrDefects()
    {

        return  this.maxCircCorrDefects;
    }
    public void setMaxCircCorrDefects(String maxCircCorrDefects)
    {

      this.maxCircCorrDefects=maxCircCorrDefects;
    }


    public String getPipeBodyRepair()
    {

        return  this.pipeBodyRepair;
    }
    public void setPipeBodyRepair(String pipeBodyRepair)
    {

      this.pipeBodyRepair=pipeBodyRepair;
    }


    public String getTestingDate()
    {

        return  this.testingDate;
    }
    public void setTestingDate(String testingDate)
    {

      this.testingDate=testingDate;
    }


    public String getTestingCompany()
    {

        return  this.testingCompany;
    }
    public void setTestingCompany(String testingCompany)
    {

      this.testingCompany=testingCompany;
    }


    public String getRecorder()
    {

        return  this.recorder;
    }
    public void setRecorder(String recorder)
    {

      this.recorder=recorder;
    }


    public String getRecordTime()
    {

        return  this.recordTime;
    }
    public void setRecordTime(String recordTime)
    {

      this.recordTime=recordTime;
    }


    public String getRemarks()
    {

        return  this.remarks;
    }
    public void setRemarks(String remarks)
    {

      this.remarks=remarks;
    }


    public String getId()
    {

        return  this.id;
    }
    public void setId(String id)
    {

      this.id=id;
    }





}